Data Types
Table 2-2 shows how the Sybase data types are mapped to the standard ODBC data types.
Table 2-2. Sybase Data Types
|
Sybase
|
ODBC
|
|
binary
|
SQL_BINARY
|
|
bit
|
SQL_BIT
|
|
char
|
SQL_CHAR
|
|
date
|
SQL_TYPE_DATE
|
|
datetime
|
SQL_TYPE_TIMESTAMP
|
|
decimal
|
SQL_DECIMAL
|
|
float
|
SQL_FLOAT
|
|
image
|
SQL_LONGVARBINARY
|
|
int
|
SQL_INTEGER
|
|
money
|
SQL_DECIMAL
|
|
numeric
|
SQL_NUMERIC
|
|
real
|
SQL_REAL
|
|
smalldatetime
|
SQL_TYPE_TIMESTAMP
|
|
smallint
|
SQL_SMALLINT
|
|
smallmoney
|
SQL_DECIMAL
|
|
sysname
|
SQL_VARCHAR
|
|
text
|
SQL_LONGVARCHAR
|
|
time
|
SQL_TYPE_TIME
|
|
timestamp
|
SQL_VARBINARY
|
|
tinyint
|
SQL_TINYINT
|
|
varbinary
|
SQL_VARBINARY
|
|
varchar
|
SQL_VARCHAR
|
NOTE FOR USERS OF ADAPTIVE SERVER 12.5: The Sybase Wire Protocol driver supports extended new limits (XNL) for character and binary columns—columns with lengths greater than 255.